Runtime Data Operations

The following topics explain how to perform data operations like sorting, filtering, paging and grouping to your grid when data is bounded dynamically.

Sorting

To implement sorting, you need to handle the Sorting and Sorted events. Use the following code to rebind the grid in the Sorted event:

To write the code in Visual Basic

Visual Basic	Copy Code
Protected Sub C1GridView1_Sorting(sender As Object, e As C1.Web.Wijmo.Controls.C1GridView.C1GridViewSortEventArgs) Handles C1GridView1.Sorting End Sub 'Handles Sorting Protected Sub C1GridView1_Sorted(sender As Object, e As EventArgs) Handles C1GridView1.Sorted C1GridView1.DataSource = BindGrid() C1GridView1.DataBind() End Sub

To write the code in C#

C#	Copy Code
protected void C1GridView1_Sorting(object sender, C1.Web.Wijmo.Controls.C1GridView.C1GridViewSortEventArgs e) { } //Handles Sorting protected void C1GridView1_Sorted(object sender, EventArgs e) { C1GridView1.DataSource = BindGrid(); C1GridView1.DataBind(); }

Filtering

To implement filtering, you need to handle the Filtering and Filtered events. Use the following code to rebind the grid in the Filtered event:

To write the code in Visual Basic

Visual Basic	Copy Code
Protected Sub C1GridView1_Filtering(sender As Object, e As C1.Web.Wijmo.Controls.C1GridView.C1GridViewFilterEventArgs) End Sub 'Handles Filtering Protected Sub C1GridView1_Filtered(sender As Object, e As EventArgs) Handles C1GridView1.Filtered C1GridView1.DataSource = BindGrid() C1GridView1.DataBind() End Sub

To write the code in C#

C#	Copy Code
protected void C1GridView1_Filtering(object sender, C1.Web.Wijmo.Controls.C1GridView.C1GridViewFilterEventArgs e) { } //Handles Filtering protected void C1GridView1_Filtered(object sender, EventArgs e) { C1GridView1.DataSource = BindGrid(); C1GridView1.DataBind(); }

Paging

To implement paging, you need to handle the Paging event. Use the following code to rebind the grid in the grid after you set the NewPageIndex as the PageIndex of C1GridView:

To write the code in Visual Basic

Visual Basic	Copy Code
'Handles Paging Protected Sub C1GridView1_PageIndexChanging(sender As Object, e As C1.Web.Wijmo.Controls.C1GridView.C1GridViewPageEventArgs) Handles C1GridView1.PageIndexChanging C1GridView1.PageIndex = e.NewPageIndex C1GridView1.DataSource = BindGrid() C1GridView1.DataBind() End Sub

To write the code in C#

C#	Copy Code
//Handles Paging protected void C1GridView1_PageIndexChanging(object sender, C1.Web.Wijmo.Controls.C1GridView.C1GridViewPageEventArgs e) { C1GridView1.PageIndex = e.NewPageIndex; C1GridView1.DataSource = BindGrid(); C1GridView1.DataBind(); }

Grouping

To implement grouping, you need to handle the ColumnGrouped and ColumnUngrouped events.

Note: For grouping C1GridView, set AllowColMoving and ShowGroupArea properties to true.

Use the following code to rebind the grid in the ColumnGrouped event while providing HeaderText of the dragged column as the parameter:

To write the code in Visual Basic

Visual Basic	Copy Code
'Handles Column UnGrouping Protected Sub C1GridView1_ColumnUngrouped(sender As Object, e As C1.Web.Wijmo.Controls.C1GridView.C1GridViewColumnUngroupedEventArgs) Handles C1GridView1.ColumnUngrouped End Sub 'Handles Column Grouping Protected Sub C1GridView1_ColumnGrouped(sender As Object, e As C1.Web.Wijmo.Controls.C1GridView.C1GridViewColumnGroupedEventArgs) Handles C1GridView1.ColumnGrouped C1GridView1.DataSource = BindGrid(e.Drag.HeaderText) C1GridView1.DataBind() End Sub

To write the code in C#

C#	Copy Code
//Handles Column UnGrouping protected void C1GridView1_ColumnUngrouped(object sender, C1.Web.Wijmo.Controls.C1GridView.C1GridViewColumnUngroupedEventArgs e) { } //Handles Column Grouping protected void C1GridView1_ColumnGrouped(object sender, C1.Web.Wijmo.Controls.C1GridView.C1GridViewColumnGroupedEventArgs e) { C1GridView1.DataSource = BindGrid(e.Drag.HeaderText); C1GridView1.DataBind(); }

TBH

Using the Property Builder